Data set

unconfirmed public water supplies that are not NYC reservoirs

use_assessment n
IR3_fully-supported_unconfirmed 6
IR3_impaired_unconfirmed 40
IR3_stressed_unconfirmed 8

Map of unconfirmed PWS with PWL IDs

SDWIS Data

merge unconfirmed PWS with PWL IDs with SDWIS ids (NOTE SDWIS IDs are draft as of 1/27/2022)

Then Rank PWS by population served

OGR data source with driver: ESRI Shapefile Source: “C:_Prioritization_layer”, layer: “pws_10_2021” with 293 features It has 12 fields Integer64 fields read as strings: OBJECTID OGR data source with driver: ESRI Shapefile Source: “C:_Prioritization_layer”, layer: “dec_wipwl_lakes” with 2096 features It has 27 fields

Consider those that are: surface water (‘Primary.Source’) PopulationServed.Count

PWS without PWLIDs

Map of PWS that don’t have PWL IDs